The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!
From the Wiki University
What evidence can you provide to prove your understanding of each of the following citeria?
Identify SQL requirements from the specification documentation
|
|
Determine information to be used from database Completed |
Evidence:
|
Identify tables that hold this information Completed |
Evidence:
|
Identify primary keys in these tables Completed |
Evidence:
|
Identify relationships between these tables, including foreign keys Completed |
Evidence:
|
Create a relational database
|
|
Create tables in a database using SQL statements Completed |
Evidence:
|
Identify primary and foreign keys for database table Completed |
Evidence:
|
Manipulate data in a database using SQL statements Completed |
Evidence:
|
Query the database using SQL statements Completed |
Evidence:
|
Write SQL statements to retrieve information from database Completed |
Evidence:
|
Test SQL results
|
|
Construct test data to test SQL statements Completed |
Evidence:
|
Construct expected results to verify SQL statements Completed |
Evidence:
|
Verify result of the constructed SQL statements against expected results Completed |
Evidence:
|